Function Libraries Group on the Metrics Tab

The Acumen metric editor supports all MS Excel functions. Use the ribbon commands to select MS Excel formulas.

The most commonly used formulas are grouped in the Common function library. Other function libraries include:

• Financial
• Logical
• Text
• Date & Time
• Lookup & Reference
• Math & Trig
• Statistical
• Information

Acumen Functions

The Acumen functions library includes the following functions:

• FISCALPERIODNUM: Use this function to return the corresponding fiscal period number for a given DateTime. The function includes two parameters:
  • Any date field on the object
  • The Project field

  For example: FISCALPERIODNUM(Start, Project)